Employee Name Basic Salary DA            (20% of Basic) Special Pay 1/2*(basic+da) Incentive      Double of (Basic + Special) Gross Salary PF              (12% OF Basic+DA) Net Salary (Gross Salary-PF)
P 50000            
Q 40000            
R 10000            
S 90000            
T 8000            
Total 198000            

how to solve this sum/example in basic excel with formula?

Krunal Mehta's image